Jim Hook ✭✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	27

About Me

About Me

Area of Expertise	Web Forms
About Me	With a background in electronics, computer science and semiconductor testing I missed the technical involvement after 11 years of retirement and ended up helping out at Breyta in a number of roles as the company has grown quickly over the last three years.
How I Use Smartsheet	I provide project timekeeping and financial analysis for a small company with Fortune 500 clients located mainly in the US and Europe. With Smartsheet I keep realtime track of the 40+ projects underway at any point in time and provide feedback to managers and supervisors that continually helps them to improve estimating and project execution processes.

Analytics

258

Posts

66

Visits

1.7k

Points

Apr 6, 2015

Join Date

Jan 17, 2024

Last Active

Reactions

• Insightful 6

  6
• Vote Up 11

  11
• Awesome 2

  2

• Activity
• Discussions27
• Comments231

• Re: Alternating Row Colors

  Jim Hook

  10/07/15
  Another way I do this is to format the first two rows as I want them, row one has a fill and row two is no fill, for example. Then copy the cells in the first two rows (not using copy-row) then selec…
  1 ·

• Re: Link Separate Smartsheets into a 'super sheet'

  Jim Hook

  10/28/15
  There are two possible ways to do this in Smartsheet. The first way that I use most often is to create a separate project summary sheet where one or more rows will be dedicated to each project. Then …
  2 ·

• Re: How can I archive sheets that I no longer use?

  Jim Hook

  04/07/15
  I routinely use Export to Excel to save sheets that I might want to refer to in the future without keeping them active and thus counting against the number of sheets I have. After exporting the sheet…
  1 ·

• Conditional Formatting a cell with a formula that resolves to blank.

  Jim Hook

  07/04/21
  I have a sheet with a column that is filled with formulas that brings in text data from another sheet. If the formula resolves to some text I want to highlight the cell with yellow. If the formula re…
  1 ·

• Re: How can I copy all conversations from one row to a row in another sheet?

  Jim Hook

  01/31/22
  Genevieve, yes, we are talking about the conversations/comments as you mentioned in your reply. Your copy/paste method used to work but something changed a year or two ago. I had been doing copy/past…
  1 ·

Next